CREATE VIEW [dbo].[vActivityReport]
as
    SELECT g.ID as                     Id,
           g.OriginalTransaction as    TransNumber,
           g.InvoiceReferenceNumber as InvRefNumber,
           g.TransactionDate as        TransactionDate,
           g.Campaign as               Campaign,  
           g.Appeal as                 Appeal,
           g.Fund as                   Fund,
           g.Amount as                 NetDonation,
           g.Amount as                 PaymentsAmount,
           0 as                        Balance,
           n.FULL_NAME as              FullName,
           n.MEMBER_TYPE as            MemberType,
           n.COMPANY_RECORD as         CompanyRecord,
           n.COMPANY as                Company,
           GiftType as                 DonationType
    FROM vGift g INNER JOIN Name n  ON g.ID = n.ID
UNION
    SELECT p.ID as                     Id,
           p.TransactionNumber as      TransNumber,
           p.InvoiceReferenceNumber as InvRefNumber,
           p.TransactionDate as        TransactionDate,
           p.Campaign as               Campaign,
           p.Appeal as                 Appeal,
           p.Fund as                   Fund,
           p.NetPledgeAmount as        NetDonation,
           p.PaymentsAmount as         PaymentsAmount,
           p.PledgeBalance as          Balance,
           n.FULL_NAME as              FullName,
           n.MEMBER_TYPE as            MemberType,
           n.COMPANY_RECORD as         CompanyRecord,
           n.COMPANY as                Company,
           'Pledge' as                 DonationType
    FROM vPledge p INNER JOIN Name n on p.ID = n.ID

GO
GRANT REFERENCES ON  [dbo].[vActivityReport] TO [IMIS]
GRANT SELECT ON  [dbo].[vActivityReport] TO [IMIS]
GRANT INSERT ON  [dbo].[vActivityReport] TO [IMIS]
GRANT DELETE ON  [dbo].[vActivityReport] TO [IMIS]
GRANT UPDATE ON  [dbo].[vActivityReport] TO [IMIS]
GO